Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemSellingPricesID (PK) | A unique system assigned identifier for the ItemSellingPrices. | ID_ITM_SL_PRC | Identity | integer | |
PermanentSaleUnitRetailPriceAmount | The sale unit monetary value of the item which is the original retail minus permanent markdowns taken against this item. | RP_PR_SLS | MoneyShortRetail | decimal(7,2) | |
PermanentSaleUnitRetailPriceOriginalMarkdownFlag | This flag indicates whether the permanent sale unit retail price amount is the original retail value or the value after one or more permanent markdowns. | FL_MKD_ORGL_PRC_PR | Flag | integer | |
PermanentRetailPricePermanentMarkdownCount | The number of permanent markdowns taken against this item. | QU_MKD_PR_PRC_PR | QuantityTransactionCount | decimal(7,0) | |
PermanentRetailPriceEffectiveDate | The date when the permanent retail price becomes effective. This will impact the stock ledger valuation (retail method). | DC_PRC_EF_PRN_RT | DateCalendar | date | |
CurrentSaleUnitRetailPriceAmount | The current retail price per sale unit of the item. This monetary amount is used as the basis for deriving retail price at the point of sale. | RP_SLS_CRT | MoneyShortRetail | decimal(7,2) | |
CurrentSaleUnitRetailPriceTypeCode | Defines the type of retail price represented in the item-current-sale-unit-retail-price-amount. Examples include marked down merchandise (permanent markdown price), promotional markdown (temporarily marked down and owned at low. | TY_PRC_RT | Code2 | char(2) | |
CurrentSaleUnitRetailPricePointAllowedFlag | This flag determines whether this ITEM may or may not have an associted price point. | FL_PRC_RT_PNT_ALW | Flag | integer | |
CurrentSaleUnitRetailPriceEffectiveDate | The date on which the item-current-sale-retail-price-amount becomes effective and is used as the basis for deriving the retail price used at the point of sale. | DC_PRC_SLS_EF_CRT | EffectiveDate | date | |
CurrentSaleUnitRetailPriceExpirationDate | The date the item-current-sale-unit-retail-price-amount expires and is no longer valid as the basis for deriving the point of sale price. | DC_PRC_SLS_EP_CRT | ExpirationDate | date | |
ManufacturerSaleUnitRecommendedRetailPriceAmount | The suggested sale unit retail price provided by the item's manufacturer. | RP_PRC_MF_RCM_RT | MoneyShortRetail | decimal(7,2) | |
ManufacturerSaleUnitRecommendedRetailPriceEffectiveDate | The date the manufacturer's suggested retail price becomes effective. | DC_PRC_MF_RCM_RT | EffectiveDate | date | |
CompareAtSaleUnitRetailPriceAmount | Provides the monetary saving that can be gained by the purchase of this ITEM at this time from this RETAIL STORE. Used as a promotional tool, this saving (normally between the normal selling retail price and the price shown at the point of sale) is usually printed on the shelf label and the customer receipt to reinforce the marketing strategy of this retailer. | RP_PRC_CMPR_AT_SLS | MoneyShortRetail | decimal(7,2) | |
QuantityPricingFlag | Denotes whether the item is priced using Quantity Package Price (Eg: 3 for $0.89) | FL_QTY_PRC | Flag | integer | |
CurrentPackagePriceQuantity | The Quantity part of the current package quantity price (Eg: 3 for $1.00) | QU_PCKG_PRC_CRT | QuantityShortCount | decimal(3,0) | |
CurrentPackagePrice | The Price part of the current package quantity price (Eg: 3 for $1.00) | RP_PCKG_PRC_CRT | MoneyShortRetail | decimal(7,2) | |
PermanentPackagePriceQuantity | The Quantity part of the permanent package quantity price (Eg: 3 for $1.00) | QU_PCKG_PRC_PRN | QuantityShortCount | decimal(3,0) | |
PermanentPackagePrice | The Price part of the permanent package quantity price (Eg: 3 for $1.00) | RP_PCKG_PRC_PRN | MoneyShortRetail | decimal(7,2) | |
PermanentSaleUnitReturnPrice | The ordinary or regular price to be refunded when the item is returned by a customer. | RP_RTN_UN_PRN_SLS | MoneyShortRetail | decimal(7,2) | |
CurrentSaleUnitReturnPrice | The crrent price to be refunded when the item is returned by a customer. | RP_RTN_UN_CRT_SLS | MoneyShortRetail | decimal(7,2) | |
IncludesSalesTaxFlag | Indicates if the prices include all applicable sales taxes or not. | FL_TX_INC | Flag | integer | |
PermanentSalesTaxAmount | The total of all applicable taxes on the PermanentSalesPrice Note: This value only has meaning when ItemSellingPrices is related to RetailStoreGroupItem. | MO_AMT_TX_PRN | MoneyShortRetail | decimal(7,2) | |
CurrentSalesTaxAmount | The total of all applicable taxes on the CurrentSalesPrice Note: This value only has meaning when ItemSellingPrices is related to RetailStoreGroupItem. | MO_AMT_TX_CRT | MoneyShortRetail | decimal(7,2) | |
MinimumAdvertisedRetailUnitPrice | A contractually defined retail unit prices that establishes a minimum value that may be ADVERTISED for an item. The retailer may sell the item for any retail price it deems appoprirate - this value establishes a floor value which for ADVERTISING and promotiong an item. | RP_MNM_ADVRTSD | MoneyShortRetail | decimal(7,2) | |
MinimumAdvertisedRetailUnitPriceEffectiveDate | Data upon which the minimum advertised retail unit price is in force. | DC_EF_RP_MNM_ADVRTSD | EffectiveDate | date | |